package com.gscitysfy.cus.drain.modules.command.mapper;

import com.gscitysfy.cus.drain.modules.command.dto.StatisticalData;
import com.gscitysfy.cus.drain.modules.command.entity.DangerSituationManage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author Administrator
 * @since 2022-10-20 21:01:08
 */
public interface DangerSituationManageMapper extends BaseMapper<DangerSituationManage> {
    List<Map<String,Object>> getXqTjList(@Param("dimon")String dimon);

    List<Map<String,Object>> getXqLXLYTjList(@Param("dimon")String dimon);
    List<StatisticalData> getQXCDList(@Param("dimon")String dimon );


    List<StatisticalData> getXqTjListByYear(@Param("startDate") String startDate, @Param("endDate")String endDate);

    List<StatisticalData> getXqTjListByMouth(@Param("year") String year);

    List<StatisticalData> getXqTjListByQuarter(@Param("startDate") String startDate, @Param("endDate")String endDate);

    StatisticalData getXqTjListByXunQi(@Param("startDate") String startDate, @Param("endDate")String endDate);

    List<StatisticalData> getXqTjListByMouthQxrw(@Param("year") String year);

    List<StatisticalData> getXqTjListByYearQxrw(@Param("startDate") String startDate, @Param("endDate")String endDate);

    List<StatisticalData> getXqTjListByQuarterQxrw(@Param("startDate") String startDate, @Param("endDate")String endDate);

    StatisticalData getXqTjListByXunQiQxrw(@Param("startDate") String startDate, @Param("endDate")String endDate);
}
